Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1197
Missing cells	506
Missing cells (%)	2.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	140.4 KiB
Average record size in memory	120.1 B

Variable types

Categorical	5
Numeric	10

Alerts

`date` has a high cardinality: 59 distinct values	High cardinality
`smv` is highly correlated with `department` and 5 other fields	High correlation
`over_time` is highly correlated with `date` and 3 other fields	High correlation
`incentive` is highly correlated with `date`	High correlation
`idle_time` is highly correlated with `idle_men`	High correlation
`idle_men` is highly correlated with `idle_time`	High correlation
`no_of_workers` is highly correlated with `department` and 3 other fields	High correlation
`day` is highly correlated with `date`	High correlation
`quarter` is highly correlated with `date`	High correlation
`date` is highly correlated with `quarter` and 6 other fields	High correlation
`department` is highly correlated with `date` and 4 other fields	High correlation
`team` is highly correlated with `smv` and 1 other fields	High correlation
`targeted_productivity` is highly correlated with `actual_productivity`	High correlation
`wip` is highly correlated with `date`	High correlation
`no_of_style_change` is highly correlated with `date` and 2 other fields	High correlation
`actual_productivity` is highly correlated with `targeted_productivity` and 1 other fields	High correlation
`wip` has 506 (42.3%) missing values	Missing
`idle_time` is highly skewed (γ1 = 20.54542523)	Skewed
`date` is uniformly distributed	Uniform
`over_time` has 31 (2.6%) zeros	Zeros
`incentive` has 604 (50.5%) zeros	Zeros
`idle_time` has 1179 (98.5%) zeros	Zeros
`idle_men` has 1179 (98.5%) zeros	Zeros

Reproduction

Analysis started	2022-10-19 23:33:20.138937
Analysis finished	2022-10-19 23:33:45.172630
Duration	25.03 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

date
Categorical

HIGH CARDINALITY
HIGH CORRELATION
UNIFORM

Distinct	59
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Memory size	9.5 KiB

3/11/2015	24
1/31/2015	24
1/11/2015	23
3/10/2015	23
1/12/2015	23
Other values (54)	1080

Length

Max length	9
Median length	9
Mean length	8.613199666
Min length	8

Characters and Unicode

Total characters	10310
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1/1/2015
2nd row	1/1/2015
3rd row	1/1/2015
4th row	1/1/2015
5th row	1/1/2015

Common Values

Value	Count	Frequency (%)
3/11/2015	24	2.0%
1/31/2015	24	2.0%
1/11/2015	23	1.9%
3/10/2015	23	1.9%
1/12/2015	23	1.9%
1/24/2015	23	1.9%
1/8/2015	22	1.8%
1/10/2015	22	1.8%
1/7/2015	22	1.8%
1/13/2015	22	1.8%
Other values (49)	969	81.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
3/11/2015	24	2.0%
1/31/2015	24	2.0%
1/11/2015	23	1.9%
3/10/2015	23	1.9%
1/12/2015	23	1.9%
1/24/2015	23	1.9%
3/9/2015	22	1.8%
1/22/2015	22	1.8%
3/3/2015	22	1.8%
3/8/2015	22	1.8%
Other values (49)	969	81.0%

Most occurring characters

Value	Count	Frequency (%)
/	2394	23.2%
1	2314	22.4%
2	2065	20.0%
5	1336	13.0%
0	1276	12.4%
3	339	3.3%
8	145	1.4%
4	141	1.4%
7	122	1.2%
9	99	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7916	76.8%
Other Punctuation	2394	23.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2314	29.2%
2	2065	26.1%
5	1336	16.9%
0	1276	16.1%
3	339	4.3%
8	145	1.8%
4	141	1.8%
7	122	1.5%
9	99	1.3%
6	79	1.0%

Other Punctuation

Value	Count	Frequency (%)
/	2394	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10310	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
/	2394	23.2%
1	2314	22.4%
2	2065	20.0%
5	1336	13.0%
0	1276	12.4%
3	339	3.3%
8	145	1.4%
4	141	1.4%
7	122	1.2%
9	99	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10310	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	2394	23.2%
1	2314	22.4%
2	2065	20.0%
5	1336	13.0%
0	1276	12.4%
3	339	3.3%
8	145	1.4%
4	141	1.4%
7	122	1.2%
9	99	1.0%

quarter
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	9.5 KiB

Quarter1	360
Quarter2	335
Quarter4	248
Quarter3	210
Quarter5	44

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	9576
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Quarter1
2nd row	Quarter1
3rd row	Quarter1
4th row	Quarter1
5th row	Quarter1

Common Values

Value	Count	Frequency (%)
Quarter1	360	30.1%
Quarter2	335	28.0%
Quarter4	248	20.7%
Quarter3	210	17.5%
Quarter5	44	3.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
quarter1	360	30.1%
quarter2	335	28.0%
quarter4	248	20.7%
quarter3	210	17.5%
quarter5	44	3.7%

Most occurring characters

Value	Count	Frequency (%)
r	2394	25.0%
Q	1197	12.5%
u	1197	12.5%
a	1197	12.5%
t	1197	12.5%
e	1197	12.5%
1	360	3.8%
2	335	3.5%
4	248	2.6%
3	210	2.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7182	75.0%
Uppercase Letter	1197	12.5%
Decimal Number	1197	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	2394	33.3%
u	1197	16.7%
a	1197	16.7%
t	1197	16.7%
e	1197	16.7%

Decimal Number

Value	Count	Frequency (%)
1	360	30.1%
2	335	28.0%
4	248	20.7%
3	210	17.5%
5	44	3.7%

Uppercase Letter

Value	Count	Frequency (%)
Q	1197	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8379	87.5%
Common	1197	12.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	2394	28.6%
Q	1197	14.3%
u	1197	14.3%
a	1197	14.3%
t	1197	14.3%
e	1197	14.3%

Common

Value	Count	Frequency (%)
1	360	30.1%
2	335	28.0%
4	248	20.7%
3	210	17.5%
5	44	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9576	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	2394	25.0%
Q	1197	12.5%
u	1197	12.5%
a	1197	12.5%
t	1197	12.5%
e	1197	12.5%
1	360	3.8%
2	335	3.5%
4	248	2.6%
3	210	2.2%

department
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	9.5 KiB

sweing	691
finishing	257
finishing	249

Length

Max length	10
Median length	6
Mean length	7.482873851
Min length	6

Characters and Unicode

Total characters	8957
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	sweing
2nd row	finishing
3rd row	sweing
4th row	sweing
5th row	sweing

Common Values

Value	Count	Frequency (%)
sweing	691	57.7%
finishing	257	21.5%
finishing	249	20.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
sweing	691	57.7%
finishing	506	42.3%

Most occurring characters

Value	Count	Frequency (%)
i	2209	24.7%
n	1703	19.0%
s	1197	13.4%
g	1197	13.4%
w	691	7.7%
e	691	7.7%
f	506	5.6%
h	506	5.6%
	257	2.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8700	97.1%
Space Separator	257	2.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	2209	25.4%
n	1703	19.6%
s	1197	13.8%
g	1197	13.8%
w	691	7.9%
e	691	7.9%
f	506	5.8%
h	506	5.8%

Space Separator

Value	Count	Frequency (%)
	257	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8700	97.1%
Common	257	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	2209	25.4%
n	1703	19.6%
s	1197	13.8%
g	1197	13.8%
w	691	7.9%
e	691	7.9%
f	506	5.8%
h	506	5.8%

Common

Value	Count	Frequency (%)
	257	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8957	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	2209	24.7%
n	1703	19.0%
s	1197	13.4%
g	1197	13.4%
w	691	7.7%
e	691	7.7%
f	506	5.6%
h	506	5.6%
	257	2.9%

day
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	9.5 KiB

Wednesday	208
Sunday	203
Tuesday	201
Thursday	199
Monday	199

Length

Max length	9
Median length	8
Mean length	7.334168755
Min length	6

Characters and Unicode

Total characters	8779
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Thursday
2nd row	Thursday
3rd row	Thursday
4th row	Thursday
5th row	Thursday

Common Values

Value	Count	Frequency (%)
Wednesday	208	17.4%
Sunday	203	17.0%
Tuesday	201	16.8%
Thursday	199	16.6%
Monday	199	16.6%
Saturday	187	15.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
wednesday	208	17.4%
sunday	203	17.0%
tuesday	201	16.8%
thursday	199	16.6%
monday	199	16.6%
saturday	187	15.6%

Most occurring characters

Value	Count	Frequency (%)
d	1405	16.0%
a	1384	15.8%
y	1197	13.6%
u	790	9.0%
e	617	7.0%
n	610	6.9%
s	608	6.9%
T	400	4.6%
S	390	4.4%
r	386	4.4%
Other values (5)	992	11.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7582	86.4%
Uppercase Letter	1197	13.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	1405	18.5%
a	1384	18.3%
y	1197	15.8%
u	790	10.4%
e	617	8.1%
n	610	8.0%
s	608	8.0%
r	386	5.1%
h	199	2.6%
o	199	2.6%

Uppercase Letter

Value	Count	Frequency (%)
T	400	33.4%
S	390	32.6%
W	208	17.4%
M	199	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8779	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	1405	16.0%
a	1384	15.8%
y	1197	13.6%
u	790	9.0%
e	617	7.0%
n	610	6.9%
s	608	6.9%
T	400	4.6%
S	390	4.4%
r	386	4.4%
Other values (5)	992	11.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8779	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	1405	16.0%
a	1384	15.8%
y	1197	13.6%
u	790	9.0%
e	617	7.0%
n	610	6.9%
s	608	6.9%
T	400	4.6%
S	390	4.4%
r	386	4.4%
Other values (5)	992	11.3%

team
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.426900585

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.463963285
Coefficient of variation (CV)	0.5389788187
Kurtosis	-1.223905739
Mean	6.426900585
Median Absolute Deviation (MAD)	3
Skewness	0.009847502797
Sum	7693
Variance	11.99904164
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
8	109	9.1%
2	109	9.1%
1	105	8.8%
4	105	8.8%
9	104	8.7%
10	100	8.4%
12	99	8.3%
7	96	8.0%
3	95	7.9%
6	94	7.9%
Other values (2)	181	15.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	105	8.8%
2	109	9.1%
3	95	7.9%
4	105	8.8%
5	93	7.8%
6	94	7.9%
7	96	8.0%
8	109	9.1%
9	104	8.7%
10	100	8.4%

Value	Count	Frequency (%)
12	99	8.3%
11	88	7.4%
10	100	8.4%
9	104	8.7%
8	109	9.1%
7	96	8.0%
6	94	7.9%
5	93	7.8%
4	105	8.8%
3	95	7.9%

targeted_productivity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7296324144

Minimum	0.07
Maximum	0.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	0.07
5-th percentile	0.5
Q1	0.7
median	0.75
Q3	0.8
95-th percentile	0.8
Maximum	0.8
Range	0.73
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.09789096326
Coefficient of variation (CV)	0.1341647675
Kurtosis	5.613700571
Mean	0.7296324144
Median Absolute Deviation (MAD)	0.05
Skewness	-2.144150033
Sum	873.37
Variance	0.009582640688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0.8	540	45.1%
0.7	242	20.2%
0.75	216	18.0%
0.65	63	5.3%
0.6	57	4.8%
0.5	49	4.1%
0.35	27	2.3%
0.4	2	0.2%
0.07	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.07	1	0.1%
0.35	27	2.3%
0.4	2	0.2%
0.5	49	4.1%
0.6	57	4.8%
0.65	63	5.3%
0.7	242	20.2%
0.75	216	18.0%
0.8	540	45.1%

Value	Count	Frequency (%)
0.8	540	45.1%
0.75	216	18.0%
0.7	242	20.2%
0.65	63	5.3%
0.6	57	4.8%
0.5	49	4.1%
0.4	2	0.2%
0.35	27	2.3%
0.07	1	0.1%

smv
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	70
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.0621721

Minimum	2.9
Maximum	54.56
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	2.9
5-th percentile	2.9
Q1	3.94
median	15.26
Q3	24.26
95-th percentile	30.1
Maximum	54.56
Range	51.66
Interquartile range (IQR)	20.32

Descriptive statistics

Standard deviation	10.9432192
Coefficient of variation (CV)	0.7265365931
Kurtosis	-0.7953459064
Mean	15.0621721
Median Absolute Deviation (MAD)	11.11
Skewness	0.4059367369
Sum	18029.42
Variance	119.7540464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.94	192	16.0%
2.9	108	9.0%
22.52	103	8.6%
30.1	79	6.6%
4.15	76	6.3%
18.79	50	4.2%
4.6	46	3.8%
15.26	44	3.7%
25.9	32	2.7%
11.61	31	2.6%
Other values (60)	436	36.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.9	108	9.0%
3.9	20	1.7%
3.94	192	16.0%
4.08	21	1.8%
4.15	76	6.3%
4.3	17	1.4%
4.6	46	3.8%
5.13	26	2.2%
10.05	6	0.5%
11.41	30	2.5%

Value	Count	Frequency (%)
54.56	1	0.1%
51.02	1	0.1%
50.89	1	0.1%
50.48	2	0.2%
49.1	1	0.1%
48.84	2	0.2%
48.68	1	0.1%
48.18	1	0.1%
45.67	1	0.1%
42.97	2	0.2%

wip
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	548
Distinct (%)	79.3%
Missing	506
Missing (%)	42.3%
Infinite	0
Infinite (%)	0.0%
Mean	1190.465991

Minimum	7
Maximum	23122
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	7
5-th percentile	358.5
Q1	774.5
median	1039
Q3	1252.5
95-th percentile	1602
Maximum	23122
Range	23115
Interquartile range (IQR)	478

Descriptive statistics

Standard deviation	1837.455001
Coefficient of variation (CV)	1.543475424
Kurtosis	101.7020449
Mean	1190.465991
Median Absolute Deviation (MAD)	232
Skewness	9.741786274
Sum	822612
Variance	3376240.881
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1039	5	0.4%
1282	4	0.3%
1422	3	0.3%
1216	3	0.3%
1413	3	0.3%
1448	3	0.3%
759	3	0.3%
1095	3	0.3%
1108	3	0.3%
1079	3	0.3%
Other values (538)	658	55.0%
(Missing)	506	42.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	1	0.1%
10	1	0.1%
11	1	0.1%
12	1	0.1%
13	1	0.1%
14	1	0.1%
15	1	0.1%
29	1	0.1%
30	1	0.1%
52	1	0.1%

Value	Count	Frequency (%)
23122	1	0.1%
21540	1	0.1%
21385	1	0.1%
21266	1	0.1%
16882	1	0.1%
12261	1	0.1%
9792	1	0.1%
8992	1	0.1%
2984	1	0.1%
2698	1	0.1%

over_time
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	143
Distinct (%)	11.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4567.460317

Minimum	0
Maximum	25920
Zeros	31
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	0
5-th percentile	960
Q1	1440
median	3960
Q3	6960
95-th percentile	10368
Maximum	25920
Range	25920
Interquartile range (IQR)	5520

Descriptive statistics

Standard deviation	3348.823563
Coefficient of variation (CV)	0.7331916054
Kurtosis	0.4243642959
Mean	4567.460317
Median Absolute Deviation (MAD)	2760
Skewness	0.6732872953
Sum	5467250
Variance	11214619.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
960	129	10.8%
1440	111	9.3%
6960	61	5.1%
6840	48	4.0%
1200	39	3.3%
1800	38	3.2%
10170	36	3.0%
0	31	2.6%
3360	30	2.5%
4080	30	2.5%
Other values (133)	644	53.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	31	2.6%
120	1	0.1%
240	6	0.5%
360	2	0.2%
480	1	0.1%
600	4	0.3%
720	4	0.3%
840	2	0.2%
900	2	0.2%
960	129	10.8%

Value	Count	Frequency (%)
25920	1	0.1%
15120	1	0.1%
15000	2	0.2%
14640	1	0.1%
13800	1	0.1%
12600	1	0.1%
12180	1	0.1%
12000	1	0.1%
10770	1	0.1%
10620	22	1.8%

incentive
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	48
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.21052632

Minimum	0
Maximum	3600
Zeros	604
Zeros (%)	50.5%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	50
95-th percentile	88
Maximum	3600
Range	3600
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	160.1826428
Coefficient of variation (CV)	4.192107732
Kurtosis	299.0324621
Mean	38.21052632
Median Absolute Deviation (MAD)	0
Skewness	15.79074602
Sum	45738
Variance	25658.47905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0	604	50.5%
50	113	9.4%
63	61	5.1%
45	54	4.5%
30	52	4.3%
23	38	3.2%
38	29	2.4%
60	28	2.3%
40	27	2.3%
75	24	2.0%
Other values (38)	167	14.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	604	50.5%
21	1	0.1%
23	38	3.2%
24	2	0.2%
25	1	0.1%
26	9	0.8%
27	2	0.2%
29	1	0.1%
30	52	4.3%
32	1	0.1%

Value	Count	Frequency (%)
3600	1	0.1%
2880	1	0.1%
1440	1	0.1%
1200	1	0.1%
1080	1	0.1%
960	5	0.4%
138	1	0.1%
119	2	0.2%
113	21	1.8%
100	7	0.6%

idle_time
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	12
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7301587302

Minimum	0
Maximum	300
Zeros	1179
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	300
Range	300
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.70975652
Coefficient of variation (CV)	17.40684045
Kurtosis	442.6381603
Mean	0.7301587302
Median Absolute Deviation (MAD)	0
Skewness	20.54542523
Sum	874
Variance	161.5379108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	1179	98.5%
3.5	3	0.3%
2	2	0.2%
5	2	0.2%
8	2	0.2%
4.5	2	0.2%
4	2	0.2%
90	1	0.1%
150	1	0.1%
270	1	0.1%
Other values (2)	2	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1179	98.5%
2	2	0.2%
3.5	3	0.3%
4	2	0.2%
4.5	2	0.2%
5	2	0.2%
6.5	1	0.1%
8	2	0.2%
90	1	0.1%
150	1	0.1%

Value	Count	Frequency (%)
300	1	0.1%
270	1	0.1%
150	1	0.1%
90	1	0.1%
8	2	0.2%
6.5	1	0.1%
5	2	0.2%
4.5	2	0.2%
4	2	0.2%
3.5	3	0.3%

idle_men
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	10
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3692564745

Minimum	0
Maximum	45
Zeros	1179
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	45
Range	45
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.268987324
Coefficient of variation (CV)	8.852891011
Kurtosis	102.9628693
Mean	0.3692564745
Median Absolute Deviation (MAD)	0
Skewness	9.855079124
Sum	442
Variance	10.68627813
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1179	98.5%
10	3	0.3%
15	3	0.3%
30	3	0.3%
20	3	0.3%
35	2	0.2%
45	1	0.1%
37	1	0.1%
25	1	0.1%
40	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1179	98.5%
10	3	0.3%
15	3	0.3%
20	3	0.3%
25	1	0.1%
30	3	0.3%
35	2	0.2%
37	1	0.1%
40	1	0.1%
45	1	0.1%

Value	Count	Frequency (%)
45	1	0.1%
40	1	0.1%
37	1	0.1%
35	2	0.2%
30	3	0.3%
25	1	0.1%
20	3	0.3%
15	3	0.3%
10	3	0.3%
0	1179	98.5%

no_of_style_change
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	9.5 KiB

0	1050
1	114
2	33

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1197
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1050	87.7%
1	114	9.5%
2	33	2.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	1050	87.7%
1	114	9.5%
2	33	2.8%

Most occurring characters

Value	Count	Frequency (%)
0	1050	87.7%
1	114	9.5%
2	33	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1197	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1050	87.7%
1	114	9.5%
2	33	2.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	1197	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1050	87.7%
1	114	9.5%
2	33	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1197	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1050	87.7%
1	114	9.5%
2	33	2.8%

no_of_workers
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	61
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.60985798

Minimum	2
Maximum	89
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	9
median	34
Q3	57
95-th percentile	59
Maximum	89
Range	87
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	22.19768668
Coefficient of variation (CV)	0.6413689041
Kurtosis	-1.788107905
Mean	34.60985798
Median Absolute Deviation (MAD)	24
Skewness	-0.1117397312
Sum	41428
Variance	492.737294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	262	21.9%
58	114	9.5%
57	109	9.1%
59	75	6.3%
10	60	5.0%
56.5	54	4.5%
56	49	4.1%
34	43	3.6%
9	42	3.5%
12	37	3.1%
Other values (51)	352	29.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	6	0.5%
4	1	0.1%
5	3	0.3%
6	1	0.1%
7	3	0.3%
8	262	21.9%
9	42	3.5%
10	60	5.0%
11	1	0.1%
12	37	3.1%

Value	Count	Frequency (%)
89	1	0.1%
60	7	0.6%
59.5	5	0.4%
59	75	6.3%
58.5	21	1.8%
58	114	9.5%
57.5	25	2.1%
57	109	9.1%
56.5	54	4.5%
56	49	4.1%

actual_productivity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	879
Distinct (%)	73.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.735091097

Minimum	0.233705476
Maximum	1.1204375
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.5 KiB

Quantile statistics

Minimum	0.233705476
5-th percentile	0.3555131924
Q1	0.650307143
median	0.773333333
Q3	0.850252525
95-th percentile	0.977037879
Maximum	1.1204375
Range	0.886732024
Interquartile range (IQR)	0.199945382

Descriptive statistics

Standard deviation	0.1744879035
Coefficient of variation (CV)	0.2373690883
Kurtosis	0.3332273412
Mean	0.735091097
Median Absolute Deviation (MAD)	0.090833333
Skewness	-0.8074917745
Sum	879.9040431
Variance	0.03044602847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.800401961	24	2.0%
0.971866667	12	1.0%
0.850136766	12	1.0%
0.75065101	11	0.9%
0.850502311	11	0.9%
1.000230409	11	0.9%
0.800128721	8	0.7%
0.750395513	8	0.7%
0.858143939	7	0.6%
0.800117103	7	0.6%
Other values (869)	1086	90.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.233705476	1	0.1%
0.235795455	1	0.1%
0.238041667	1	0.1%
0.24625	1	0.1%
0.247316017	1	0.1%
0.249416667	1	0.1%
0.251399254	1	0.1%
0.2565	1	0.1%
0.258	1	0.1%
0.259375	1	0.1%

Value	Count	Frequency (%)
1.1204375	1	0.1%
1.108125	1	0.1%
1.100483918	1	0.1%
1.096633333	1	0.1%
1.059621212	1	0.1%
1.057962963	1	0.1%
1.050666667	1	0.1%
1.05028058	1	0.1%
1.033570076	1	0.1%
1.033155556	1	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	date	quarter	department	day	team	targeted_productivity	smv	wip	over_time	incentive	no_of_workers	actual_productivity
0	1/1/2015	Quarter1	sweing	Thursday	8	0.80	26.16	1108.0	7080	98	59.0	0.940725
1	1/1/2015	Quarter1	finishing	Thursday	1	0.75	3.94	NaN	960	0	8.0	0.886500
2	1/1/2015	Quarter1	sweing	Thursday	11	0.80	11.41	968.0	3660	50	30.5	0.800570
3	1/1/2015	Quarter1	sweing	Thursday	12	0.80	11.41	968.0	3660	50	30.5	0.800570
4	1/1/2015	Quarter1	sweing	Thursday	6	0.80	25.90	1170.0	1920	50	56.0	0.800382
5	1/1/2015	Quarter1	sweing	Thursday	7	0.80	25.90	984.0	6720	38	56.0	0.800125
6	1/1/2015	Quarter1	finishing	Thursday	2	0.75	3.94	NaN	960	0	8.0	0.755167
7	1/1/2015	Quarter1	sweing	Thursday	3	0.75	28.08	795.0	6900	45	57.5	0.753683
8	1/1/2015	Quarter1	sweing	Thursday	2	0.75	19.87	733.0	6000	34	55.0	0.753098
9	1/1/2015	Quarter1	sweing	Thursday	1	0.75	28.08	681.0	6900	45	57.5	0.750428

Last rows

	date	quarter	department	day	team	targeted_productivity	smv	wip	over_time	incentive	no_of_style_change	no_of_workers	actual_productivity
1187	3/11/2015	Quarter2	sweing	Wednesday	4	0.75	26.82	1054.0	7080	45	0	59.0	0.750051
1188	3/11/2015	Quarter2	sweing	Wednesday	5	0.70	26.82	992.0	6960	30	1	58.0	0.700557
1189	3/11/2015	Quarter2	sweing	Wednesday	8	0.70	30.48	914.0	6840	30	1	57.0	0.700505
1190	3/11/2015	Quarter2	sweing	Wednesday	6	0.70	23.41	1128.0	4560	40	1	38.0	0.700246
1191	3/11/2015	Quarter2	sweing	Wednesday	7	0.65	30.48	935.0	6840	26	1	57.0	0.650596
1192	3/11/2015	Quarter2	finishing	Wednesday	10	0.75	2.90	NaN	960	0	0	8.0	0.628333
1193	3/11/2015	Quarter2	finishing	Wednesday	8	0.70	3.90	NaN	960	0	0	8.0	0.625625
1194	3/11/2015	Quarter2	finishing	Wednesday	7	0.65	3.90	NaN	960	0	0	8.0	0.625625
1195	3/11/2015	Quarter2	finishing	Wednesday	9	0.75	2.90	NaN	1800	0	0	15.0	0.505889
1196	3/11/2015	Quarter2	finishing	Wednesday	6	0.70	2.90	NaN	720	0	0	6.0	0.394722

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)